-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: localhost    Database: bingo
-- ------------------------------------------------------
-- Server version	5.6.23-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `basedata`
--

DROP TABLE IF EXISTS `basedata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `basedata` (
  `RuleNO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `ValueFrom` varchar(60) DEFAULT NULL,
  `ValueTo` varchar(60) DEFAULT NULL,
  `Level` varchar(120) DEFAULT NULL,
  `Version` int(10) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `ParentNo` int(10) DEFAULT NULL,
  `DisplayOrder` int(4) DEFAULT NULL,
  PRIMARY KEY (`RuleNO`)
) ENGINE=InnoDB AUTO_INCREMENT=900000176 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `basedata`
--

LOCK TABLES `basedata` WRITE;
/*!40000 ALTER TABLE `basedata` DISABLE KEYS */;
INSERT INTO `basedata` VALUES (900000001,'Nature','Active','','','校级',NULL,'校级',NULL,NULL),(900000002,'Nature','Active','','','院级',NULL,'院级',NULL,NULL),(900000003,'StudentInterval','Active','0','100','1-100人',NULL,'1-100人',NULL,NULL),(900000004,'StudentInterval','Active','101','300','101-300人',NULL,'101-300人',NULL,NULL),(900000005,'StudentInterval','Active','301','500','301-500人',NULL,'301-500人',NULL,NULL),(900000006,'StudentInterval','Active','501','1000','501-1000人',NULL,'501-1000人',NULL,NULL),(900000007,'StudentInterval','Active','1001','1500','1001-1500人',NULL,'1001-1500人',NULL,NULL),(900000008,'StudentInterval','Active','1501','2500','1501-2500人',NULL,'1500人以上',NULL,NULL),(900000009,'StudentInterval','Active','2501','3000','2501-3000人',NULL,'2501-3000人',NULL,NULL),(900000010,'StudentInterval','Active','3000','3000000000','3000人以上',NULL,'3000人以上',NULL,NULL),(900000011,'SponsorMoney','Active','500','2500','500-2500',NULL,'500-2500',NULL,NULL),(900000012,'SponsorMoney','Active','2501','5000','2501-5000',NULL,'2501-5000',NULL,NULL),(900000013,'SponsorMoney','Active','5001','7500','5001-7500',NULL,'5001-7500',NULL,NULL),(900000014,'SponsorMoney','Active','7501','10000','7501-10000',NULL,'7501-10000',NULL,NULL),(900000015,'SponsorMoney','Active','10001','15000','10001-15000',NULL,'10001-15000',NULL,NULL),(900000016,'SponsorMoney','Active','15001','20000','15001-20000',NULL,'15001-20000',NULL,NULL),(900000017,'SponsorMoney','Active','20001','25000','20001-25000',NULL,'20001-25000',NULL,NULL),(900000018,'SponsorMoney','Active','25001','30000','25001-30000',NULL,'25001-30000',NULL,NULL),(900000019,'SponsorMoney','Active','30001','50000','30001-50000',NULL,'30001-50000',NULL,NULL),(900000020,'SponsorMoney','Active','50001','70000','50001-70000',NULL,'50001-70000',NULL,NULL),(900000021,'SponsorMoney','Active','70001','100000','70001-100000',NULL,'70001-100000',NULL,NULL),(900000022,'SponsorMoney','Active','100001','150000','100001-150000',NULL,'100001-150000',NULL,NULL),(900000023,'SponsorMoney','Active','150001','200000','150001-200000',NULL,'150001-200000',NULL,NULL),(900000024,'SponsorMoney','Active','200000','200000000','200000以上',NULL,'200000以上',NULL,NULL),(900000025,'StudentLevel','Active','','','官方代理社团',NULL,'官方代理社团',NULL,NULL),(900000026,'StudentLevel','Active','500','5000000','金牌社团',NULL,'金牌社团',NULL,NULL),(900000027,'StudentLevel','Active','400','500','银牌社团',NULL,'银牌社团',NULL,NULL),(900000028,'StudentLevel','Active','300','400','铜牌社团',NULL,'铜牌社团',NULL,NULL),(900000029,'StudentLevel','Active','200','300','普通社团V3',NULL,'普通社团V3',NULL,NULL),(900000030,'StudentLevel','Active','100','200','普通社团V2',NULL,'普通社团V2',NULL,NULL),(900000031,'StudentLevel','Active','0','100','普通社团V1',NULL,'普通社团V1',NULL,NULL),(900000032,'SponsorMoney','Active','','','2000',NULL,'2000',NULL,NULL),(900000033,'SponsorMultiple','Active','','','5',NULL,'5',NULL,NULL),(900000034,'CancelRemark','Active','','','活动信息错误',NULL,'活动信息错误',NULL,NULL),(900000035,'CancelRemark','Active','','','活动长时间没收到邀请',NULL,'活动长时间没收到邀请',NULL,NULL),(900000036,'CancelRemark','Active','','','活动需要重新发布',NULL,'活动需要重新发布',NULL,NULL),(900000037,'CancelRemark','Active','','','活动已达成目的',NULL,'活动已达成目的',NULL,NULL),(900000038,'CancelRemark','Active','','','活动时间过期',NULL,'活动时间过期',NULL,NULL),(900000039,'CancelRemark','Active','','','用户自主下架',NULL,'用户自主下架',NULL,NULL),(900000040,'ActivityType','Active','','','招新类',NULL,'招新类',NULL,NULL),(900000041,'ActivityType','Active','','','文艺类',NULL,'文艺类',NULL,NULL),(900000042,'ActivityType','Active','','','表演类',NULL,'表演类',NULL,NULL),(900000043,'ActivityType','Active','','','晚会类',NULL,'晚会类',NULL,NULL),(900000044,'ActivityType','Active','','','体育类',NULL,'体育类',NULL,NULL),(900000045,'ActivityType','Active','','','讲座类',NULL,'讲座类',NULL,NULL),(900000046,'ActivityType','Active','','','比赛类',NULL,'比赛类',NULL,NULL),(900000047,'ActivityType','Active','','','其它',NULL,'其它',NULL,NULL),(900000048,'AssosiationType','Active','','','组织类-学生会',NULL,'组织类-学生会',NULL,NULL),(900000049,'AssosiationType','Active','','','组织类-团委',NULL,'组织类-团委',NULL,NULL),(900000050,'AssosiationType','Active','','','组织类-社团联合会',NULL,'组织类-社团联合会',NULL,NULL),(900000051,'AssosiationType','Active','','','组织类-其他',NULL,'组织类-其他',NULL,NULL),(900000052,'AssosiationType','Active','','','社团类-青年志愿者服务队',NULL,'社团类-青年志愿者服务队',NULL,NULL),(900000053,'AssosiationType','Active','','','社团类-红十字会',NULL,'社团类-红十字会',NULL,NULL),(900000054,'AssosiationType','Active','','','社团类-体育类社团',NULL,'社团类-体育类社团',NULL,NULL),(900000055,'AssosiationType','Active','','','社团类-棋牌类社团',NULL,'社团类-棋牌类社团',NULL,NULL),(900000056,'AssosiationType','Active','','','社团类-动漫社',NULL,'社团类-动漫社',NULL,NULL),(900000057,'AssosiationType','Active','','','社团类-文娱类社团',NULL,'社团类-文娱类社团',NULL,NULL),(900000058,'AssosiationType','Active','','','社团类-兴趣类社团',NULL,'社团类-兴趣类社团',NULL,NULL),(900000059,'AssosiationType','Active','','','社团类-其他社团',NULL,'社团类-其他社团',NULL,NULL),(900000060,'CompanyMaterial','Active','','','公司产品',NULL,'公司产品',NULL,NULL),(900000061,'CompanyMaterial','Active','','','传单 ',NULL,'传单 ',NULL,NULL),(900000062,'CompanyMaterial','Active','','','音箱',NULL,'音箱',NULL,NULL),(900000063,'CompanyMaterial','Active','','','横幅',NULL,'横幅',NULL,NULL),(900000064,'CompanyMaterial','Active','','','帐篷',NULL,'帐篷',NULL,NULL),(900000065,'CompanyMaterial','Active','','','桌椅',NULL,'桌椅',NULL,NULL),(900000066,'CompanyMaterial','Active','','','活动展架',NULL,'活动展架',NULL,NULL),(900000067,'CompanyMaterial','Active','','','活动海报',NULL,'活动海报',NULL,NULL),(900000068,'CompanyMaterial','Active','','','其他',NULL,'其他',NULL,NULL),(900000069,'AssociationMaterial','Active','','','横幅',NULL,'横幅',NULL,NULL),(900000070,'AssociationMaterial','Active','','','传单(黑白，彩色)',NULL,'传单(黑白，彩色)',NULL,NULL),(900000071,'AssociationMaterial','Active','','','KT板',NULL,'KT板',NULL,NULL),(900000072,'AssociationMaterial','Active','','','幕布',NULL,'幕布',NULL,NULL),(900000073,'AssociationMaterial','Active','','','易拉宝',NULL,'易拉宝',NULL,NULL),(900000074,'AssociationMaterial','Active','','','推头',NULL,'推头',NULL,NULL),(900000075,'AssociationMaterial','Active','','','灯布',NULL,'灯布',NULL,NULL),(900000076,'AssociationMaterial','Active','','','木构',NULL,'木构',NULL,NULL),(900000077,'AssociationMaterial','Active','','','展位',NULL,'展位',NULL,NULL),(900000078,'AssociationMaterial','Active','','','灯箱',NULL,'灯箱',NULL,NULL),(900000079,'AssociationMaterial','Active','','','桁架',NULL,'桁架',NULL,NULL),(900000080,'AssociationMaterial','Active','','','麦克风(耳麦，手麦，麦架)',NULL,'麦克风(耳麦，手麦，麦架)',NULL,NULL),(900000081,'AssociationMaterial','Active','','','帐篷',NULL,'帐篷',NULL,NULL),(900000082,'AssociationMaterial','Active','','','桌椅',NULL,'桌椅',NULL,NULL),(900000083,'AssociationMaterial','Active','','','音箱',NULL,'音箱',NULL,NULL),(900000084,'AssociationMaterial','Active','','','活动展架',NULL,'活动展架',NULL,NULL),(900000085,'AssociationMaterial','Active','','','活动海报',NULL,'活动海报',NULL,NULL),(900000086,'AssociationMaterial','Active','','','其他',NULL,'其他',NULL,NULL),(900000087,'CheckCompanyRejectedRemark','Active','','','不存在您所输入的代理官口号令',NULL,'不存在您所输入的代理官口号令',NULL,NULL),(900000088,'CheckCompanyRejectedRemark','Active','','','企业全称与营业执照上的不一致',NULL,'企业全称与营业执照上的不一致',NULL,NULL),(900000089,'CheckCompanyRejectedRemark','Active','','','企业地址不详细',NULL,'企业地址不详细',NULL,NULL),(900000090,'CheckCompanyRejectedRemark','Active','','','企业网址无法正常打开或网站内容不全',NULL,'企业网址无法正常打开或网站内容不全',NULL,NULL),(900000091,'CheckCompanyRejectedRemark','Active','','','注册人姓名与身份证不一致',NULL,'注册人姓名与身份证不一致',NULL,NULL),(900000092,'CheckCompanyRejectedRemark','Active','','','未上传正确的身份证',NULL,'未上传正确的身份证',NULL,NULL),(900000093,'CheckCompanyRejectedRemark','Active','','','执照名称或注册号与营业执照不一致',NULL,'执照名称或注册号与营业执照不一致',NULL,NULL),(900000094,'CheckCompanyRejectedRemark','Active','','','未上传正确的营业执照',NULL,'未上传正确的营业执照',NULL,NULL),(900000095,'CheckCompanyRejectedRemark','Active','','','邮箱未验证',NULL,'邮箱未验证',NULL,NULL),(900000096,'CheckAssociationRejectedRemark','Active','','','所属院系不正确或不存在',NULL,'所属院系不正确或不存在',NULL,NULL),(900000097,'CheckAssociationRejectedRemark','Active','','','注册人姓名与身份证不一致',NULL,'注册人姓名与身份证不一致',NULL,NULL),(900000098,'CheckAssociationRejectedRemark','Active','','','注册人学号与学生证不一致',NULL,'注册人学号与学生证不一致',NULL,NULL),(900000099,'CheckAssociationRejectedRemark','Active','','','邮箱未验证',NULL,'邮箱未验证',NULL,NULL),(900000100,'CheckAssociationRejectedRemark','Active','','','未上传正确的身份证',NULL,'未上传正确的身份证',NULL,NULL),(900000101,'CheckAssociationRejectedRemark','Active','','','未上传正确的学生证',NULL,'未上传正确的学生证',NULL,NULL),(900000102,'AssociationSize','Active','1','10','1-10人',NULL,'1-10人',NULL,NULL),(900000103,'AssociationSize','Active','11','30','11-30人',NULL,'11-30人',NULL,NULL),(900000104,'AssociationSize','Active','31','60','31-60人',NULL,'31-60人',NULL,NULL),(900000105,'AssociationSize','Active','61','90','61-90人',NULL,'61-90人',NULL,NULL),(900000106,'AssociationSize','Active','91','120','91-120人',NULL,'91-120人',NULL,NULL),(900000107,'AssociationSize','Active','121','150','121-150人',NULL,'121-150人',NULL,NULL),(900000108,'AssociationSize','Active','151','200','151-200人',NULL,'151-200人',NULL,NULL),(900000109,'AssociationSize','Active','201','250','201-250人',NULL,'201-250人',NULL,NULL),(900000110,'AssociationSize','Active','251','300','251-300人',NULL,'251-300人',NULL,NULL),(900000111,'AssociationSize','Active','300','1000000','300人以上',NULL,'300人以上',NULL,NULL),(900000112,'AssociationSchoolType','Active','','','组织类',NULL,'组织类',NULL,NULL),(900000113,'AssociationSchoolType','Active','','','社团类',NULL,'社团类',NULL,NULL),(900000114,'AssociationRejectRemark','Active','','','信息不匹配',NULL,'信息不匹配',NULL,NULL),(900000115,'AssociationRejectRemark','Active','','','企业赞助金不适合',NULL,'企业赞助金不适合',NULL,NULL),(900000116,'AssociationRejectRemark','Active','','','企业所在地不是所需所在地 ',NULL,'企业所在地不是所需所在地 ',NULL,NULL),(900000117,'AssociationRejectRemark','Active','','','已受邀于其他企业赞助',NULL,'已受邀于其他企业赞助',NULL,NULL),(900000118,'AssociationRejectRemark','Active','','','其他',NULL,'其他',NULL,NULL),(900000119,'CompanyRejectRemark','Active','','','信息不匹配',NULL,'信息不匹配',NULL,NULL),(900000120,'CompanyRejectRemark','Active','','','社团规模太小',NULL,'社团规模太小',NULL,NULL),(900000121,'CompanyRejectRemark','Active','','','社团所在地不是所需所在地 ',NULL,'社团所在地不是所需所在地 ',NULL,NULL),(900000122,'CompanyRejectRemark','Active','','','已受邀于其他社团活动',NULL,'已受邀于其他社团活动',NULL,NULL),(900000123,'CompanyRejectRemark','Active','','','其他',NULL,'其他',NULL,NULL),(900000124,'AssociationProjectReject','Active','','','信息不正确',NULL,'信息不正确',NULL,NULL),(900000125,'AssociationProjectReject','Active','','','活动名称错误',NULL,'活动名称错误',NULL,NULL),(900000126,'AssociationProjectReject','Active','','','活动所需金额超过限定范围',NULL,'活动所需金额超过限定范围',NULL,NULL),(900000127,'AssociationProjectReject','Active','','','社团活动书所属社团已达到3个合作中的合同',NULL,'社团活动书所属社团已达到3个合作中的合同',NULL,NULL),(900000128,'CompanyProjectReject','Active','','','信息不正确',NULL,'信息不正确',NULL,NULL),(900000129,'CompanyProjectReject','Active','','','活动名称错误',NULL,'活动名称错误',NULL,NULL),(900000130,'CompanyProjectReject','Active','','','赞助提供金额超出平台限定',NULL,'赞助提供金额超出平台限定',NULL,NULL),(900000131,'CompanyProjectReject','Active','','','赞助时间过长',NULL,'赞助时间过长',NULL,NULL),(900000132,'AgentReward','Active','0','5000','赞助金的8%',NULL,'赞助金的8%',NULL,NULL),(900000133,'AgentReward','Active','5001','10000','赞助金的8.5%',NULL,'赞助金的8.5%',NULL,NULL),(900000134,'AgentReward','Active','10001','15000','赞助金的9%',NULL,'赞助金的9%',NULL,NULL),(900000135,'AgentReward','Active','15001','20000','赞助金的9.5%',NULL,'赞助金的9.5%',NULL,NULL),(900000136,'AgentReward','Active','20001','200000000','赞助金的10%',NULL,'赞助金的10%',NULL,NULL),(900000137,'CompanyType','Active','','','外资独资（欧美企业）',NULL,'外资独资（欧美企业）',NULL,NULL),(900000138,'CompanyType','Active','','','外资独资（非欧美企业）',NULL,'外资独资（非欧美企业）',NULL,NULL),(900000139,'CompanyType','Active','','','合资/合作（欧美企业）',NULL,'合资/合作（欧美企业）',NULL,NULL),(900000140,'CompanyType','Active','','','合资/合作（非欧美企业）',NULL,'合资/合作（非欧美企业）',NULL,NULL),(900000141,'CompanyType','Active','','','国营企业/上市企业',NULL,'国营企业/上市企业',NULL,NULL),(900000142,'CompanyType','Active','','','民营/私营企业/非上市企业',NULL,'民营/私营企业/非上市企业',NULL,NULL),(900000143,'CompanyType','Active','','','外企代表处',NULL,'外企代表处',NULL,NULL),(900000144,'CompanyType','Active','','','其他',NULL,'其他',NULL,NULL),(900000145,'CompanySize','Active','0','50','小于50人',NULL,'小于50人',NULL,NULL),(900000146,'CompanySize','Active','50','150','50-150人',NULL,'50-150人',NULL,NULL),(900000147,'CompanySize','Active','151','500','151-500人',NULL,'151-500人',NULL,NULL),(900000148,'CompanySize','Active','501','2000','501-2000人',NULL,'501-2000人',NULL,NULL),(900000149,'CompanySize','Active','2000','','2000人以上',NULL,'2000人以上',NULL,NULL),(900000150,'CompanyIndustry','Active','','','家电',NULL,'家电',NULL,NULL),(900000151,'CompanyIndustry','Active','','','通讯',NULL,'通讯',NULL,NULL),(900000152,'CompanyIndustry','Active','','','房产建材',NULL,'房产建材',NULL,NULL),(900000153,'CompanyIndustry','Active','','','医疗保健',NULL,'医疗保健',NULL,NULL),(900000154,'CompanyIndustry','Active','','','工业制造',NULL,'工业制造',NULL,NULL),(900000155,'CompanyIndustry','Active','','','现代服务',NULL,'现代服务',NULL,NULL),(900000156,'CompanyIndustry','Active','','','日用消费品',NULL,'日用消费品',NULL,NULL),(900000157,'CompanyIndustry','Active','','','酒店餐饮',NULL,'酒店餐饮',NULL,NULL),(900000158,'CompanyIndustry','Active','','','食品饮料',NULL,'食品饮料',NULL,NULL),(900000159,'CompanyIndustry','Active','','','化妆',NULL,'化妆',NULL,NULL),(900000160,'CompanyIndustry','Active','','','汽车',NULL,'汽车',NULL,NULL),(900000161,'CompanyIndustry','Active','','','服装',NULL,'服装',NULL,NULL),(900000162,'CompanyIndustry','Active','','','奢饰品',NULL,'奢饰品',NULL,NULL),(900000163,'CompanyIndustry','Active','','','IT',NULL,'IT',NULL,NULL),(900000164,'CompanyIndustry','Active','','','珠宝饰品',NULL,'珠宝饰品',NULL,NULL),(900000165,'CompanyIndustry','Active','','','广告企业',NULL,'广告企业',NULL,NULL),(900000166,'CompanyIndustry','Active','','','烟酒类',NULL,'烟酒类',NULL,NULL),(900000167,'CompanyIndustry','Active','','','金融',NULL,'金融',NULL,NULL),(900000168,'CompanyIndustry','Active','','','旅游航空',NULL,'旅游航空',NULL,NULL),(900000169,'CompanyIndustry','Active','','','其他',NULL,'其他',NULL,NULL),(900000170,'AgentPassword','Active','','','代理官口号',NULL,'代理官口号',NULL,NULL),(900000171,'RebateRate','Active','0','5000','0.08',NULL,'0.08',NULL,NULL),(900000172,'RebateRate','Active','5001','10000','0.085',NULL,'0.085',NULL,NULL),(900000173,'RebateRate','Active','10001','15000','0.09',NULL,'0.09',NULL,NULL),(900000174,'RebateRate','Active','15001','20000','0.095',NULL,'0.095',NULL,NULL),(900000175,'RebateRate','Active','20001','99999999','0.10',NULL,'0.10',NULL,NULL);
/*!40000 ALTER TABLE `basedata` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-03-10 16:13:36
